
TGTDB=scott/tiger

crtbl_t_server()
{

sqlplus $TGTDB << !
DROP TABLE T_SERVER CASCADE CONSTRAINTS;
CREATE TABLE T_SERVER (
US_NDTYP		CHAR(	2) NOT NULL,
TA_SRVGRP		CHAR(	30),
TA_SRVID		NUMBER(	5) NOT NULL,
TA_SERVERNAME	CHAR(	78),
TA_RQADDR		CHAR(	30),
TA_MAX			NUMBER(	4),
TA_MIN			NUMBER(	4),
TA_CLOPT		CHAR(	256),
US_SVRTYP		CHAR(	2),
US_EAICFG		CHAR(	32),
US_DBCFGINFO	CHAR(	32),
US_ISXA			CHAR(	1)
);
!

}

crtbl_t_service()
{

sqlplus $TGTDB << !
DROP TABLE T_SERVICE CASCADE CONSTRAINTS;
CREATE TABLE T_SERVICE (
US_NDTYP		CHAR(	2) NOT NULL,
TA_SRVID		NUMBER(	5) NOT NULL,
TA_SERVICENAME	CHAR(	15) NOT NULL,
TA_SVCTIMEOUT	NUMBER(	5),
TA_NCOMPLETED	NUMBER(	8)
);
!

}

#echo $TGTDB
#crtbl_t_server
crtbl_t_service



